﻿<%@ Page Language="C#" MasterPageFile="~/MasterPageMcSigAdmin.master" AutoEventWireup="true" CodeFile="EtcCDP.aspx.cs" Inherits="EtcCDP" Title="Untitled Page" %>

<%@ Register Assembly="DevExpress.Web.ASPxGridView.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxGridView" TagPrefix="dx" %>
<%@ Register Assembly="DevExpress.Web.ASPxEditors.v9.3, Version=9.3.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a"
    Namespace="DevExpress.Web.ASPxEditors" TagPrefix="dx" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css"
        CssPostfix="PlasticBlue" DataSourceID="SqlDataSource1" KeyFieldName="FCD_ID">
        <Styles CssFilePath="~/App_Themes/PlasticBlue/{0}/styles.css" CssPostfix="PlasticBlue">
            <Header ImageSpacing="10px" SortingImageSpacing="10px">
            </Header>
        </Styles>
        <SettingsPager ShowDefaultImages="False">
            <AllButton Text="All">
            </AllButton>
            <NextPageButton Text="Next &gt;">
            </NextPageButton>
            <PrevPageButton Text="&lt; Prev">
            </PrevPageButton>
        </SettingsPager>
        <ImagesFilterControl>
            <LoadingPanel Url="~/App_Themes/PlasticBlue/Editors/Loading.gif">
            </LoadingPanel>
        </ImagesFilterControl>
        <Images SpriteCssFilePath="~/App_Themes/PlasticBlue/{0}/sprite.css">
            <LoadingPanelOnStatusBar Url="~/App_Themes/PlasticBlue/GridView/gvLoadingOnStatusBar.gif">
            </LoadingPanelOnStatusBar>
            <LoadingPanel Url="~/App_Themes/PlasticBlue/GridView/Loading.gif">
            </LoadingPanel>
        </Images>
        <Columns>
            <dx:GridViewCommandColumn VisibleIndex="0">
                <EditButton Visible="True">
                </EditButton>
                <NewButton Visible="True">
                </NewButton>
                <DeleteButton Visible="True">
                </DeleteButton>
            </dx:GridViewCommandColumn>
            <dx:GridViewDataTextColumn FieldName="FCD_ID" ReadOnly="True" VisibleIndex="1">
                <EditFormSettings Visible="False" />
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="FCD_NUMERO_CDP" VisibleIndex="2">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataDateColumn FieldName="FCD_FECHA_CDP" VisibleIndex="3">
            </dx:GridViewDataDateColumn>
            <dx:GridViewDataTextColumn FieldName="FCD_VALOR_CDP" VisibleIndex="4">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="FCE_ID" VisibleIndex="5">
            </dx:GridViewDataTextColumn>
            <dx:GridViewDataTextColumn FieldName="FCD_VALOR_CDP_FINAL" VisibleIndex="6">
            </dx:GridViewDataTextColumn>
        </Columns>
        <Settings ShowFilterRow="True" ShowGroupPanel="True" />
        <StylesEditors>
            <CalendarHeader Spacing="11px">
            </CalendarHeader>
            <ProgressBar Height="25px">
            </ProgressBar>
        </StylesEditors>
    </dx:ASPxGridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MCSIGConnectionString %>"
        DeleteCommand="DELETE FROM [FIN_CDP] WHERE [FCD_ID] = ?" InsertCommand="INSERT INTO [FIN_CDP] ([FCD_ID], [FCD_NUMERO_CDP], [FCD_FECHA_CDP], [FCD_VALOR_CDP], [FCE_ID], [FCD_VALOR_CDP_FINAL]) VALUES (?, ?, ?, ?, ?, ?)"
        ProviderName="<%$ ConnectionStrings:MCSIGConnectionString.ProviderName %>" SelectCommand="SELECT [FCD_ID], [FCD_NUMERO_CDP], [FCD_FECHA_CDP], [FCD_VALOR_CDP], [FCE_ID], [FCD_VALOR_CDP_FINAL] FROM [FIN_CDP]"
        UpdateCommand="UPDATE [FIN_CDP] SET [FCD_NUMERO_CDP] = ?, [FCD_FECHA_CDP] = ?, [FCD_VALOR_CDP] = ?, [FCE_ID] = ?, [FCD_VALOR_CDP_FINAL] = ? WHERE [FCD_ID] = ?">
        <DeleteParameters>
            <asp:Parameter Name="FCD_ID" Type="Decimal" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="FCD_NUMERO_CDP" Type="String" />
            <asp:Parameter Name="FCD_FECHA_CDP" Type="DateTime" />
            <asp:Parameter Name="FCD_VALOR_CDP" Type="Decimal" />
            <asp:Parameter Name="FCE_ID" Type="Decimal" />
            <asp:Parameter Name="FCD_VALOR_CDP_FINAL" Type="Decimal" />
            <asp:Parameter Name="FCD_ID" Type="Decimal" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="FCD_ID" Type="Decimal" />
            <asp:Parameter Name="FCD_NUMERO_CDP" Type="String" />
            <asp:Parameter Name="FCD_FECHA_CDP" Type="DateTime" />
            <asp:Parameter Name="FCD_VALOR_CDP" Type="Decimal" />
            <asp:Parameter Name="FCE_ID" Type="Decimal" />
            <asp:Parameter Name="FCD_VALOR_CDP_FINAL" Type="Decimal" />
        </InsertParameters>
    </asp:SqlDataSource>
</asp:Content>

